package com.happyclub.paul.dao;

import com.happyclub.pojo.TbManualAudit;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Modifying;
import org.springframework.data.jpa.repository.Query;


/**
 * @Auther: 魏泉琦
 * @Date: 2019/4/12 09:03
 * @Description: 人工审核历史表
 */
public interface ManualAuditRepostitory extends JpaRepository<TbManualAudit,String> {

    /**
     *@Description: 保存审核人信息
     *@Author: 魏泉琦
     *@date: 2019/4/12
     */
    @Modifying
    @Query(value = "INSERT INTO TB_MANUAL_AUDIT(ART_ID,PHOTO_ID,AUDIT_MAN,IS_OK,AUDIT_DATE,AUDIT_MAN_NAME) VALUES(?,?,?,?,SYSDATE,?)",nativeQuery = true)
    Integer createManualAudit(String artId,String photoId,String autMan,long isOk,String auditManName);



}
